Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	9426
Missing cells	72
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	192.0 B

Variable types

Numeric	11
Categorical	8
Text	3
DateTime	2

Alerts

`Row ID` has unique values	Unique
`Discount` has 848 (9.0%) zeros	Zeros

Reproduction

Analysis started	2024-07-05 12:03:56.252392
Analysis finished	2024-07-05 12:04:09.490743
Duration	13.24 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

Row ID
Real number (ℝ)

UNIQUE

Distinct	9426
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20241.015

Minimum	2
Maximum	26399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	2
5-th percentile	4040.5
Q1	19330.25
median	21686.5
Q3	24042.75
95-th percentile	25927.75
Maximum	26399
Range	26397
Interquartile range (IQR)	4712.5

Descriptive statistics

Standard deviation	6101.891
Coefficient of variation (CV)	0.3014617
Kurtosis	2.9998152
Mean	20241.015
Median Absolute Deviation (MAD)	2356.5
Skewness	-1.9363104
Sum	1.9079181 × 10⁸
Variance	37233073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19914	1	< 0.1%
4561	1	< 0.1%
25101	1	< 0.1%
21561	1	< 0.1%
21058	1	< 0.1%
25099	1	< 0.1%
23922	1	< 0.1%
23923	1	< 0.1%
25622	1	< 0.1%
23931	1	< 0.1%
Other values (9416)	9416	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
27	1	< 0.1%
52	1	< 0.1%
53	1	< 0.1%
62	1	< 0.1%
63	1	< 0.1%
64	1	< 0.1%
66	1	< 0.1%
67	1	< 0.1%
68	1	< 0.1%

Value	Count	Frequency (%)
26399	1	< 0.1%
26398	1	< 0.1%
26397	1	< 0.1%
26396	1	< 0.1%
26395	1	< 0.1%
26394	1	< 0.1%
26393	1	< 0.1%
26392	1	< 0.1%
26391	1	< 0.1%
26390	1	< 0.1%

Order Priority
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

High	1970
Low	1926
Not Specified	1881
Medium	1844
Critical	1804

Length

Max length	13
Median length	8
Mean length	6.7489921
Min length	3

Characters and Unicode

Total characters	63616
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Not Specified
2nd row	Critical
3rd row	Critical
4th row	Critical
5th row	Low

Common Values

Value	Count	Frequency (%)
High	1970	20.9%
Low	1926	20.4%
Not Specified	1881	20.0%
Medium	1844	19.6%
Critical	1804	19.1%
Critical	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
high	1970	17.4%
low	1926	17.0%
not	1881	16.6%
specified	1881	16.6%
medium	1844	16.3%
critical	1805	16.0%

Most occurring characters

Value	Count	Frequency (%)
i	11186	17.6%
e	5606	8.8%
o	3807	6.0%
d	3725	5.9%
c	3686	5.8%
t	3686	5.8%
H	1970	3.1%
g	1970	3.1%
h	1970	3.1%
L	1926	3.0%
Other values (13)	24084	37.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	50427	79.3%
Uppercase Letter	11307	17.8%
Space Separator	1882	3.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	11186	22.2%
e	5606	11.1%
o	3807	7.5%
d	3725	7.4%
c	3686	7.3%
t	3686	7.3%
g	1970	3.9%
h	1970	3.9%
w	1926	3.8%
f	1881	3.7%
Other values (6)	10984	21.8%

Uppercase Letter

Value	Count	Frequency (%)
H	1970	17.4%
L	1926	17.0%
S	1881	16.6%
N	1881	16.6%
M	1844	16.3%
C	1805	16.0%

Space Separator

Value	Count	Frequency (%)
	1882	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	61734	97.0%
Common	1882	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	11186	18.1%
e	5606	9.1%
o	3807	6.2%
d	3725	6.0%
c	3686	6.0%
t	3686	6.0%
H	1970	3.2%
g	1970	3.2%
h	1970	3.2%
L	1926	3.1%
Other values (12)	22202	36.0%

Common

Value	Count	Frequency (%)
	1882	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63616	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	11186	17.6%
e	5606	8.8%
o	3807	6.0%
d	3725	5.9%
c	3686	5.8%
t	3686	5.8%
H	1970	3.1%
g	1970	3.1%
h	1970	3.1%
L	1926	3.0%
Other values (13)	24084	37.9%

Discount
Real number (ℝ)

ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049627626

Minimum	0
Maximum	0.25
Zeros	848
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.02
median	0.05
Q3	0.08
95-th percentile	0.1
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.06

Descriptive statistics

Standard deviation	0.031798425
Coefficient of variation (CV)	0.64074041
Kurtosis	-0.9872078
Mean	0.049627626
Median Absolute Deviation (MAD)	0.03
Skewness	0.072044551
Sum	467.79
Variance	0.0010111398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0.01	898	9.5%
0.03	882	9.4%
0.05	879	9.3%
0.09	871	9.2%
0.02	870	9.2%
0.04	861	9.1%
0.08	850	9.0%
0	848	9.0%
0.1	838	8.9%
0.06	821	8.7%
Other values (6)	808	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	848	9.0%
0.01	898	9.5%
0.02	870	9.2%
0.03	882	9.4%
0.04	861	9.1%
0.05	879	9.3%
0.06	821	8.7%
0.07	803	8.5%
0.08	850	9.0%
0.09	871	9.2%

Value	Count	Frequency (%)
0.25	1	< 0.1%
0.21	1	< 0.1%
0.17	1	< 0.1%
0.16	1	< 0.1%
0.11	1	< 0.1%
0.1	838	8.9%
0.09	871	9.2%
0.08	850	9.0%
0.07	803	8.5%
0.06	821	8.7%

Unit Price
Real number (ℝ)

Distinct	751
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88.303686

Minimum	0.99
Maximum	6783.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	0.99
5-th percentile	2.88
Q1	6.48
median	20.99
Q3	85.99
95-th percentile	320.64
Maximum	6783.02
Range	6782.03
Interquartile range (IQR)	79.51

Descriptive statistics

Standard deviation	281.54098
Coefficient of variation (CV)	3.1883265
Kurtosis	276.52846
Mean	88.303686
Median Absolute Deviation (MAD)	17.01
Skewness	14.135146
Sum	832350.54
Variance	79265.324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.48	298	3.2%
65.99	219	2.3%
4.98	153	1.6%
125.99	131	1.4%
5.98	118	1.3%
2.88	92	1.0%
30.98	86	0.9%
20.99	78	0.8%
35.99	78	0.8%
205.99	70	0.7%
Other values (741)	8103	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.99	2	< 0.1%
1.14	13	0.1%
1.26	14	0.1%
1.48	13	0.1%
1.6	6	0.1%
1.68	24	0.3%
1.7	9	0.1%
1.74	10	0.1%
1.76	34	0.4%
1.8	3	< 0.1%

Value	Count	Frequency (%)
6783.02	7	0.1%
3502.14	6	0.1%
3499.99	8	0.1%
2550.14	7	0.1%
2036.48	8	0.1%
1938.02	8	0.1%
1889.99	3	< 0.1%
1637.53	2	< 0.1%
1500.97	6	0.1%
1360.14	4	< 0.1%

Shipping Cost
Real number (ℝ)

Distinct	652
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.795142

Minimum	0.49
Maximum	164.73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	0.49
5-th percentile	0.8
Q1	3.1925
median	6.05
Q3	13.99
95-th percentile	55.285
Maximum	164.73
Range	164.24
Interquartile range (IQR)	10.7975

Descriptive statistics

Standard deviation	17.181203
Coefficient of variation (CV)	1.3427911
Kurtosis	7.6460144
Mean	12.795142
Median Absolute Deviation (MAD)	3.63
Skewness	2.5445189
Sum	120607.01
Variance	295.19373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.99	398	4.2%
8.99	366	3.9%
1.99	278	2.9%
0.5	217	2.3%
0.99	167	1.8%
4	158	1.7%
0.7	155	1.6%
1.49	155	1.6%
24.49	149	1.6%
2.99	142	1.5%
Other values (642)	7241	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.49	37	0.4%
0.5	217	2.3%
0.7	155	1.6%
0.71	24	0.3%
0.73	1	< 0.1%
0.75	8	0.1%
0.76	8	0.1%
0.78	8	0.1%
0.79	3	< 0.1%
0.8	25	0.3%

Value	Count	Frequency (%)
164.73	1	< 0.1%
154.12	1	< 0.1%
147.12	2	< 0.1%
143.71	1	< 0.1%
130	1	< 0.1%
126	1	< 0.1%
110.2	12	0.1%
99	7	0.1%
91.05	8	0.1%
89.3	14	0.1%

Customer ID
Real number (ℝ)

Distinct	2703
Distinct (%)	28.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1738.4222

Minimum	2
Maximum	3403
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	2
5-th percentile	181
Q1	898
median	1750
Q3	2578.75
95-th percentile	3238.75
Maximum	3403
Range	3401
Interquartile range (IQR)	1680.75

Descriptive statistics

Standard deviation	979.1672
Coefficient of variation (CV)	0.5632505
Kurtosis	-1.1834638
Mean	1738.4222
Median Absolute Deviation (MAD)	837.5
Skewness	-0.047717047
Sum	16386368
Variance	958768.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1193	27	0.3%
699	26	0.3%
2107	22	0.2%
2491	22	0.2%
2882	21	0.2%
308	21	0.2%
3079	20	0.2%
272	19	0.2%
1999	19	0.2%
1129	18	0.2%
Other values (2693)	9211	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	6	0.1%
5	2	< 0.1%
6	4	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%

Value	Count	Frequency (%)
3403	2	< 0.1%
3402	4	< 0.1%
3400	7	0.1%
3399	4	< 0.1%
3398	3	< 0.1%
3397	6	0.1%
3396	7	0.1%
3394	4	< 0.1%
3393	5	0.1%
3391	1	< 0.1%

Customer Name
Text

Distinct	2703
Distinct (%)	28.7%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Length

Max length	28
Median length	25
Mean length	13.185445
Min length	6

Characters and Unicode

Total characters	124286
Distinct characters	54
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	897 ?
Unique (%)	9.5%

Sample

1st row	Anita Hahn
2nd row	Alex Nicholson
3rd row	Alex Nicholson
4th row	Jane Shah
5th row	Ellen McCormick

Value	Count	Frequency (%)
james	60	0.3%
norman	59	0.3%
keith	58	0.3%
dana	56	0.3%
ricky	56	0.3%
andrew	56	0.3%
lindsay	55	0.3%
herbert	52	0.3%
sean	52	0.3%
ross	51	0.3%
Other values (1375)	19300	97.2%

Most occurring characters

Value	Count	Frequency (%)
e	12459	10.0%
	10429	8.4%
a	10240	8.2%
n	10235	8.2%
r	8953	7.2%
l	6776	5.5%
o	6752	5.4%
i	6681	5.4%
s	4562	3.7%
t	4323	3.5%
Other values (44)	42876	34.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93505	75.2%
Uppercase Letter	20263	16.3%
Space Separator	10429	8.4%
Other Punctuation	89	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12459	13.3%
a	10240	11.0%
n	10235	10.9%
r	8953	9.6%
l	6776	7.2%
o	6752	7.2%
i	6681	7.1%
s	4562	4.9%
t	4323	4.6%
y	3631	3.9%
Other values (16)	18893	20.2%

Uppercase Letter

Value	Count	Frequency (%)
B	1859	9.2%
M	1628	8.0%
C	1541	7.6%
S	1499	7.4%
H	1405	6.9%
J	1245	6.1%
R	1183	5.8%
G	1081	5.3%
L	1061	5.2%
K	972	4.8%
Other values (16)	6789	33.5%

Space Separator

Value	Count	Frequency (%)
	10429	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	89	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	113768	91.5%
Common	10518	8.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12459	11.0%
a	10240	9.0%
n	10235	9.0%
r	8953	7.9%
l	6776	6.0%
o	6752	5.9%
i	6681	5.9%
s	4562	4.0%
t	4323	3.8%
y	3631	3.2%
Other values (42)	39156	34.4%

Common

Value	Count	Frequency (%)
	10429	99.2%
'	89	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	124286	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12459	10.0%
	10429	8.4%
a	10240	8.2%
n	10235	8.2%
r	8953	7.2%
l	6776	5.5%
o	6752	5.4%
i	6681	5.4%
s	4562	3.7%
t	4323	3.5%
Other values (44)	42876	34.5%

Ship Mode
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Regular Air	7036
Delivery Truck	1283
Express Air	1107

Length

Max length	14
Median length	11
Mean length	11.408339
Min length	11

Characters and Unicode

Total characters	107535
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Express Air
2nd row	Regular Air
3rd row	Express Air
4th row	Regular Air
5th row	Regular Air

Common Values

Value	Count	Frequency (%)
Regular Air	7036	74.6%
Delivery Truck	1283	13.6%
Express Air	1107	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
air	8143	43.2%
regular	7036	37.3%
delivery	1283	6.8%
truck	1283	6.8%
express	1107	5.9%

Most occurring characters

Value	Count	Frequency (%)
r	18852	17.5%
e	10709	10.0%
	9426	8.8%
i	9426	8.8%
u	8319	7.7%
l	8319	7.7%
A	8143	7.6%
R	7036	6.5%
g	7036	6.5%
a	7036	6.5%
Other values (10)	13233	12.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79257	73.7%
Uppercase Letter	18852	17.5%
Space Separator	9426	8.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	18852	23.8%
e	10709	13.5%
i	9426	11.9%
u	8319	10.5%
l	8319	10.5%
g	7036	8.9%
a	7036	8.9%
s	2214	2.8%
v	1283	1.6%
y	1283	1.6%
Other values (4)	4780	6.0%

Uppercase Letter

Value	Count	Frequency (%)
A	8143	43.2%
R	7036	37.3%
T	1283	6.8%
D	1283	6.8%
E	1107	5.9%

Space Separator

Value	Count	Frequency (%)
	9426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	98109	91.2%
Common	9426	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	18852	19.2%
e	10709	10.9%
i	9426	9.6%
u	8319	8.5%
l	8319	8.5%
A	8143	8.3%
R	7036	7.2%
g	7036	7.2%
a	7036	7.2%
s	2214	2.3%
Other values (9)	11019	11.2%

Common

Value	Count	Frequency (%)
	9426	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	107535	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	18852	17.5%
e	10709	10.0%
	9426	8.8%
i	9426	8.8%
u	8319	7.7%
l	8319	7.7%
A	8143	7.6%
R	7036	6.5%
g	7036	6.5%
a	7036	6.5%
Other values (10)	13233	12.3%

Customer Segment
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Corporate	3375
Home Office	2316
Consumer	1894
Small Business	1841

Length

Max length	14
Median length	11
Mean length	10.267027
Min length	8

Characters and Unicode

Total characters	96777
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Home Office
2nd row	Consumer
3rd row	Consumer
4th row	Consumer
5th row	Corporate

Common Values

Value	Count	Frequency (%)
Corporate	3375	35.8%
Home Office	2316	24.6%
Consumer	1894	20.1%
Small Business	1841	19.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
corporate	3375	24.8%
home	2316	17.1%
office	2316	17.1%
consumer	1894	13.9%
small	1841	13.6%
business	1841	13.6%

Most occurring characters

Value	Count	Frequency (%)
e	11742	12.1%
o	10960	11.3%
r	8644	8.9%
s	7417	7.7%
m	6051	6.3%
C	5269	5.4%
a	5216	5.4%
f	4632	4.8%
	4157	4.3%
i	4157	4.3%
Other values (10)	28532	29.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79037	81.7%
Uppercase Letter	13583	14.0%
Space Separator	4157	4.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	11742	14.9%
o	10960	13.9%
r	8644	10.9%
s	7417	9.4%
m	6051	7.7%
a	5216	6.6%
f	4632	5.9%
i	4157	5.3%
u	3735	4.7%
n	3735	4.7%
Other values (4)	12748	16.1%

Uppercase Letter

Value	Count	Frequency (%)
C	5269	38.8%
O	2316	17.1%
H	2316	17.1%
S	1841	13.6%
B	1841	13.6%

Space Separator

Value	Count	Frequency (%)
	4157	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	92620	95.7%
Common	4157	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	11742	12.7%
o	10960	11.8%
r	8644	9.3%
s	7417	8.0%
m	6051	6.5%
C	5269	5.7%
a	5216	5.6%
f	4632	5.0%
i	4157	4.5%
u	3735	4.0%
Other values (9)	24797	26.8%

Common

Value	Count	Frequency (%)
	4157	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	96777	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	11742	12.1%
o	10960	11.3%
r	8644	8.9%
s	7417	7.7%
m	6051	6.3%
C	5269	5.4%
a	5216	5.4%
f	4632	4.8%
	4157	4.3%
i	4157	4.3%
Other values (10)	28532	29.5%

Product Category
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Office Supplies	5181
Technology	2312
Furniture	1933

Length

Max length	15
Median length	15
Mean length	12.543178
Min length	9

Characters and Unicode

Total characters	118232
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Office Supplies
2nd row	Office Supplies
3rd row	Office Supplies
4th row	Office Supplies
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	5181	55.0%
Technology	2312	24.5%
Furniture	1933	20.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	5181	35.5%
supplies	5181	35.5%
technology	2312	15.8%
furniture	1933	13.2%

Most occurring characters

Value	Count	Frequency (%)
e	14607	12.4%
i	12295	10.4%
p	10362	8.8%
f	10362	8.8%
u	9047	7.7%
c	7493	6.3%
l	7493	6.3%
O	5181	4.4%
s	5181	4.4%
S	5181	4.4%
Other values (10)	31030	26.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98444	83.3%
Uppercase Letter	14607	12.4%
Space Separator	5181	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	14607	14.8%
i	12295	12.5%
p	10362	10.5%
f	10362	10.5%
u	9047	9.2%
c	7493	7.6%
l	7493	7.6%
s	5181	5.3%
o	4624	4.7%
n	4245	4.3%
Other values (5)	12735	12.9%

Uppercase Letter

Value	Count	Frequency (%)
O	5181	35.5%
S	5181	35.5%
T	2312	15.8%
F	1933	13.2%

Space Separator

Value	Count	Frequency (%)
	5181	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	113051	95.6%
Common	5181	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	14607	12.9%
i	12295	10.9%
p	10362	9.2%
f	10362	9.2%
u	9047	8.0%
c	7493	6.6%
l	7493	6.6%
O	5181	4.6%
s	5181	4.6%
S	5181	4.6%
Other values (9)	25849	22.9%

Common

Value	Count	Frequency (%)
	5181	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118232	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	14607	12.4%
i	12295	10.4%
p	10362	8.8%
f	10362	8.8%
u	9047	7.7%
c	7493	6.3%
l	7493	6.3%
O	5181	4.4%
s	5181	4.4%
S	5181	4.4%
Other values (10)	31030	26.2%

Product Sub-Category
Categorical

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Paper	1379
Binders and Binder Accessories	1028
Telephones and Communication	992
Office Furnishings	883
Computer Peripherals	846
Other values (12)	4298

Length

Max length	30
Median length	22
Mean length	17.072884
Min length	5

Characters and Unicode

Total characters	160929
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Storage & Organization
2nd row	Paper
3rd row	Paper
4th row	Binders and Binder Accessories
5th row	Storage & Organization

Common Values

Value	Count	Frequency (%)
Paper	1379	14.6%
Binders and Binder Accessories	1028	10.9%
Telephones and Communication	992	10.5%
Office Furnishings	883	9.4%
Computer Peripherals	846	9.0%
Pens & Art Supplies	721	7.6%
Storage & Organization	610	6.5%
Appliances	492	5.2%
Chairs & Chairmats	440	4.7%
Tables	404	4.3%
Other values (7)	1631	17.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	2273	10.5%
	1771	8.2%
paper	1379	6.3%
office	1259	5.8%
binders	1028	4.7%
binder	1028	4.7%
accessories	1028	4.7%
telephones	992	4.6%
communication	992	4.6%
furnishings	883	4.1%
Other values (22)	9085	41.8%

Most occurring characters

Value	Count	Frequency (%)
e	17270	10.7%
s	13391	8.3%
i	13036	8.1%
n	12347	7.7%
	12292	7.6%
r	11618	7.2%
a	10740	6.7%
o	7007	4.4%
p	6859	4.3%
c	5536	3.4%
Other values (27)	50833	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	129037	80.2%
Uppercase Letter	17674	11.0%
Space Separator	12292	7.6%
Other Punctuation	1926	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	17270	13.4%
s	13391	10.4%
i	13036	10.1%
n	12347	9.6%
r	11618	9.0%
a	10740	8.3%
o	7007	5.4%
p	6859	5.3%
c	5536	4.3%
d	4524	3.5%
Other values (12)	26709	20.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2946	16.7%
C	2816	15.9%
B	2457	13.9%
A	2241	12.7%
O	1869	10.6%
T	1551	8.8%
S	1486	8.4%
F	981	5.6%
M	376	2.1%
R	350	2.0%
Other values (2)	601	3.4%

Other Punctuation

Value	Count	Frequency (%)
&	1771	92.0%
,	155	8.0%

Space Separator

Value	Count	Frequency (%)
	12292	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	146711	91.2%
Common	14218	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	17270	11.8%
s	13391	9.1%
i	13036	8.9%
n	12347	8.4%
r	11618	7.9%
a	10740	7.3%
o	7007	4.8%
p	6859	4.7%
c	5536	3.8%
d	4524	3.1%
Other values (24)	44383	30.3%

Common

Value	Count	Frequency (%)
	12292	86.5%
&	1771	12.5%
,	155	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	160929	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	17270	10.7%
s	13391	8.3%
i	13036	8.1%
n	12347	7.7%
	12292	7.6%
r	11618	7.2%
a	10740	6.7%
o	7007	4.4%
p	6859	4.3%
c	5536	3.4%
Other values (27)	50833	31.6%

Product Container
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Small Box	4887
Wrap Bag	1312
Small Pack	1067
Jumbo Drum	703
Jumbo Box	590
Other values (2)	867

Length

Max length	10
Median length	9
Mean length	9.0920857
Min length	8

Characters and Unicode

Total characters	85702
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Large Box
2nd row	Wrap Bag
3rd row	Wrap Bag
4th row	Small Box
5th row	Small Box

Common Values

Value	Count	Frequency (%)
Small Box	4887	51.8%
Wrap Bag	1312	13.9%
Small Pack	1067	11.3%
Jumbo Drum	703	7.5%
Jumbo Box	590	6.3%
Large Box	457	4.8%
Medium Box	410	4.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
box	6344	33.7%
small	5954	31.6%
wrap	1312	7.0%
bag	1312	7.0%
jumbo	1293	6.9%
pack	1067	5.7%
drum	703	3.7%
large	457	2.4%
medium	410	2.2%

Most occurring characters

Value	Count	Frequency (%)
l	11908	13.9%
a	10102	11.8%
	9426	11.0%
m	8360	9.8%
B	7656	8.9%
o	7637	8.9%
x	6344	7.4%
S	5954	6.9%
r	2472	2.9%
u	2406	2.8%
Other values (14)	13437	15.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57424	67.0%
Uppercase Letter	18852	22.0%
Space Separator	9426	11.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	11908	20.7%
a	10102	17.6%
m	8360	14.6%
o	7637	13.3%
x	6344	11.0%
r	2472	4.3%
u	2406	4.2%
g	1769	3.1%
p	1312	2.3%
b	1293	2.3%
Other values (5)	3821	6.7%

Uppercase Letter

Value	Count	Frequency (%)
B	7656	40.6%
S	5954	31.6%
W	1312	7.0%
J	1293	6.9%
P	1067	5.7%
D	703	3.7%
L	457	2.4%
M	410	2.2%

Space Separator

Value	Count	Frequency (%)
	9426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	76276	89.0%
Common	9426	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	11908	15.6%
a	10102	13.2%
m	8360	11.0%
B	7656	10.0%
o	7637	10.0%
x	6344	8.3%
S	5954	7.8%
r	2472	3.2%
u	2406	3.2%
g	1769	2.3%
Other values (13)	11668	15.3%

Common

Value	Count	Frequency (%)
	9426	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	85702	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	11908	13.9%
a	10102	11.8%
	9426	11.0%
m	8360	9.8%
B	7656	8.9%
o	7637	8.9%
x	6344	7.4%
S	5954	6.9%
r	2472	2.9%
u	2406	2.8%
Other values (14)	13437	15.7%

Product Name
Text

Distinct	1263
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Length

Max length	98
Median length	75
Mean length	34.331318
Min length	3

Characters and Unicode

Total characters	323607
Distinct characters	84
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	0.5%

Sample

1st row	Safco Industrial Wire Shelving
2nd row	White GlueTop Scratch Pads
3rd row	Black Print Carbonless Snap-Off® Rapid Letter, 8 1/2" x 7"
4th row	Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets
5th row	Dual Level, Single-Width Filing Carts

Value	Count	Frequency (%)
xerox	867	1.8%
x	555	1.2%
avery	481	1.0%
with	459	1.0%
	374	0.8%
black	373	0.8%
binders	347	0.7%
for	344	0.7%
chair	309	0.6%
staples	293	0.6%
Other values (2076)	43617	90.8%

Most occurring characters

Value	Count	Frequency (%)
	38593	11.9%
e	29027	9.0%
r	17810	5.5%
o	17376	5.4%
a	16384	5.1%
i	15730	4.9%
l	14049	4.3%
t	13937	4.3%
n	13239	4.1%
s	12819	4.0%
Other values (74)	134643	41.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	206796	63.9%
Uppercase Letter	48049	14.8%
Space Separator	38593	11.9%
Decimal Number	18604	5.7%
Other Punctuation	7091	2.2%
Dash Punctuation	2608	0.8%
Other Symbol	1552	0.5%
Final Punctuation	81	< 0.1%
Open Punctuation	78	< 0.1%
Close Punctuation	78	< 0.1%
Other values (2)	77	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29027	14.0%
r	17810	8.6%
o	17376	8.4%
a	16384	7.9%
i	15730	7.6%
l	14049	6.8%
t	13937	6.7%
n	13239	6.4%
s	12819	6.2%
c	8356	4.0%
Other values (17)	48069	23.2%

Uppercase Letter

Value	Count	Frequency (%)
S	5100	10.6%
C	4984	10.4%
P	4489	9.3%
B	4315	9.0%
D	2924	6.1%
A	2784	5.8%
M	2693	5.6%
F	2254	4.7%
T	2240	4.7%
R	1856	3.9%
Other values (16)	14410	30.0%

Decimal Number

Value	Count	Frequency (%)
1	3592	19.3%
0	3097	16.6%
2	2239	12.0%
3	1713	9.2%
8	1593	8.6%
4	1571	8.4%
9	1415	7.6%
5	1274	6.8%
6	1065	5.7%
7	1045	5.6%

Other Punctuation

Value	Count	Frequency (%)
,	3177	44.8%
/	1515	21.4%
"	1186	16.7%
.	569	8.0%
&	240	3.4%
'	171	2.4%
#	112	1.6%
*	68	1.0%
%	48	0.7%
;	5	0.1%

Other Symbol

Value	Count	Frequency (%)
®	1011	65.1%
™	541	34.9%

Open Punctuation

Value	Count	Frequency (%)
(	60	76.9%
[	18	23.1%

Close Punctuation

Value	Count	Frequency (%)
)	60	76.9%
]	18	23.1%

Space Separator

Value	Count	Frequency (%)
	38593	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2608	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	81	100.0%

Math Symbol

Value	Count	Frequency (%)
+	42	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	254845	78.8%
Common	68762	21.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29027	11.4%
r	17810	7.0%
o	17376	6.8%
a	16384	6.4%
i	15730	6.2%
l	14049	5.5%
t	13937	5.5%
n	13239	5.2%
s	12819	5.0%
c	8356	3.3%
Other values (43)	96118	37.7%

Common

Value	Count	Frequency (%)
	38593	56.1%
1	3592	5.2%
,	3177	4.6%
0	3097	4.5%
-	2608	3.8%
2	2239	3.3%
3	1713	2.5%
8	1593	2.3%
4	1571	2.3%
/	1515	2.2%
Other values (21)	9064	13.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	321937	99.5%
None	1013	0.3%
Letterlike Symbols	541	0.2%
Punctuation	116	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	38593	12.0%
e	29027	9.0%
r	17810	5.5%
o	17376	5.4%
a	16384	5.1%
i	15730	4.9%
l	14049	4.4%
t	13937	4.3%
n	13239	4.1%
s	12819	4.0%
Other values (69)	132973	41.3%

None

Value	Count	Frequency (%)
®	1011	99.8%
à	2	0.2%

Letterlike Symbols

Value	Count	Frequency (%)
™	541	100.0%

Punctuation

Value	Count	Frequency (%)
”	81	69.8%
“	35	30.2%

Product Base Margin
Real number (ℝ)

Distinct	51
Distinct (%)	0.5%
Missing	72
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.51218944

Minimum	0.35
Maximum	0.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	0.35
5-th percentile	0.36
Q1	0.38
median	0.52
Q3	0.59
95-th percentile	0.78
Maximum	0.85
Range	0.5
Interquartile range (IQR)	0.21

Descriptive statistics

Standard deviation	0.13522874
Coefficient of variation (CV)	0.26402095
Kurtosis	-0.65350818
Mean	0.51218944
Median Absolute Deviation (MAD)	0.12
Skewness	0.56124764
Sum	4791.02
Variance	0.018286813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.37	855	9.1%
0.38	754	8.0%
0.36	695	7.4%
0.59	563	6.0%
0.39	541	5.7%
0.57	523	5.5%
0.56	510	5.4%
0.4	469	5.0%
0.58	430	4.6%
0.55	355	3.8%
Other values (41)	3659	38.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.35	296	3.1%
0.36	695	7.4%
0.37	855	9.1%
0.38	754	8.0%
0.39	541	5.7%
0.4	469	5.0%
0.41	115	1.2%
0.42	86	0.9%
0.43	117	1.2%
0.44	107	1.1%

Value	Count	Frequency (%)
0.85	40	0.4%
0.84	29	0.3%
0.83	90	1.0%
0.82	34	0.4%
0.81	82	0.9%
0.8	55	0.6%
0.79	74	0.8%
0.78	100	1.1%
0.77	77	0.8%
0.76	60	0.6%

Region
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Central	2899
East	2289
West	2284
South	1954

Length

Max length	7
Median length	5
Mean length	5.1299597
Min length	4

Characters and Unicode

Total characters	48355
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	East
2nd row	West
3rd row	West
4th row	Central
5th row	West

Common Values

Value	Count	Frequency (%)
Central	2899	30.8%
East	2289	24.3%
West	2284	24.2%
South	1954	20.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
central	2899	30.8%
east	2289	24.3%
west	2284	24.2%
south	1954	20.7%

Most occurring characters

Value	Count	Frequency (%)
t	9426	19.5%
a	5188	10.7%
e	5183	10.7%
s	4573	9.5%
C	2899	6.0%
n	2899	6.0%
r	2899	6.0%
l	2899	6.0%
E	2289	4.7%
W	2284	4.7%
Other values (4)	7816	16.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38929	80.5%
Uppercase Letter	9426	19.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	9426	24.2%
a	5188	13.3%
e	5183	13.3%
s	4573	11.7%
n	2899	7.4%
r	2899	7.4%
l	2899	7.4%
o	1954	5.0%
u	1954	5.0%
h	1954	5.0%

Uppercase Letter

Value	Count	Frequency (%)
C	2899	30.8%
E	2289	24.3%
W	2284	24.2%
S	1954	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48355	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	9426	19.5%
a	5188	10.7%
e	5183	10.7%
s	4573	9.5%
C	2899	6.0%
n	2899	6.0%
r	2899	6.0%
l	2899	6.0%
E	2289	4.7%
W	2284	4.7%
Other values (4)	7816	16.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48355	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	9426	19.5%
a	5188	10.7%
e	5183	10.7%
s	4573	9.5%
C	2899	6.0%
n	2899	6.0%
r	2899	6.0%
l	2899	6.0%
E	2289	4.7%
W	2284	4.7%
Other values (4)	7816	16.2%

State or Province
Categorical

Distinct	49
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

California	1021
Texas	646
Illinois	584
New York	574
Florida	522
Other values (44)	6079

Length

Max length	20
Median length	13
Mean length	8.2980055
Min length	4

Characters and Unicode

Total characters	78217
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Maryland
2nd row	California
3rd row	California
4th row	Minnesota
5th row	California

Common Values

Value	Count	Frequency (%)
California	1021	10.8%
Texas	646	6.9%
Illinois	584	6.2%
New York	574	6.1%
Florida	522	5.5%
Ohio	396	4.2%
Michigan	327	3.5%
Washington	327	3.5%
Pennsylvania	271	2.9%
North Carolina	251	2.7%
Other values (39)	4507	47.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	1021	9.3%
new	889	8.1%
texas	646	5.9%
illinois	584	5.3%
york	574	5.3%
florida	522	4.8%
ohio	396	3.6%
carolina	356	3.3%
michigan	327	3.0%
washington	327	3.0%
Other values (43)	5290	48.4%

Most occurring characters

Value	Count	Frequency (%)
a	9856	12.6%
i	9010	11.5%
n	7026	9.0%
o	6792	8.7%
s	5299	6.8%
r	4606	5.9%
e	4372	5.6%
l	4025	5.1%
t	2172	2.8%
h	2128	2.7%
Other values (36)	22931	29.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	65847	84.2%
Uppercase Letter	10864	13.9%
Space Separator	1506	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9856	15.0%
i	9010	13.7%
n	7026	10.7%
o	6792	10.3%
s	5299	8.0%
r	4606	7.0%
e	4372	6.6%
l	4025	6.1%
t	2172	3.3%
h	2128	3.2%
Other values (14)	10561	16.0%

Uppercase Letter

Value	Count	Frequency (%)
C	1704	15.7%
M	1466	13.5%
N	1294	11.9%
I	1115	10.3%
T	812	7.5%
O	668	6.1%
Y	574	5.3%
W	560	5.2%
F	522	4.8%
A	382	3.5%
Other values (11)	1767	16.3%

Space Separator

Value	Count	Frequency (%)
	1506	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	76711	98.1%
Common	1506	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9856	12.8%
i	9010	11.7%
n	7026	9.2%
o	6792	8.9%
s	5299	6.9%
r	4606	6.0%
e	4372	5.7%
l	4025	5.2%
t	2172	2.8%
h	2128	2.8%
Other values (35)	21425	27.9%

Common

Value	Count	Frequency (%)
	1506	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	78217	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9856	12.6%
i	9010	11.5%
n	7026	9.0%
o	6792	8.7%
s	5299	6.8%
r	4606	5.9%
e	4372	5.6%
l	4025	5.1%
t	2172	2.8%
h	2128	2.7%
Other values (36)	22931	29.3%

City
Text

Distinct	1424
Distinct (%)	15.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Length

Max length	19
Median length	16
Mean length	9.1706981
Min length	3

Characters and Unicode

Total characters	86443
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	151 ?
Unique (%)	1.6%

Sample

1st row	Bowie
2nd row	Montebello
3rd row	Montebello
4th row	Prior Lake
5th row	Napa

Value	Count	Frequency (%)
city	468	3.6%
new	264	2.1%
los	222	1.7%
york	208	1.6%
angeles	203	1.6%
park	165	1.3%
san	142	1.1%
beach	116	0.9%
west	112	0.9%
heights	107	0.8%
Other values (1378)	10855	84.4%

Most occurring characters

Value	Count	Frequency (%)
e	8135	9.4%
a	7413	8.6%
o	6517	7.5%
n	6213	7.2%
l	5597	6.5%
i	5242	6.1%
r	5232	6.1%
t	4733	5.5%
s	3999	4.6%
	3436	4.0%
Other values (42)	29926	34.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	70145	81.1%
Uppercase Letter	12862	14.9%
Space Separator	3436	4.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8135	11.6%
a	7413	10.6%
o	6517	9.3%
n	6213	8.9%
l	5597	8.0%
i	5242	7.5%
r	5232	7.5%
t	4733	6.7%
s	3999	5.7%
d	2049	2.9%
Other values (16)	15015	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1540	12.0%
S	1133	8.8%
P	1004	7.8%
B	923	7.2%
M	894	7.0%
L	884	6.9%
H	744	5.8%
A	701	5.5%
W	623	4.8%
R	548	4.3%
Other values (15)	3868	30.1%

Space Separator

Value	Count	Frequency (%)
	3436	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83007	96.0%
Common	3436	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8135	9.8%
a	7413	8.9%
o	6517	7.9%
n	6213	7.5%
l	5597	6.7%
i	5242	6.3%
r	5232	6.3%
t	4733	5.7%
s	3999	4.8%
d	2049	2.5%
Other values (41)	27877	33.6%

Common

Value	Count	Frequency (%)
	3436	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86443	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8135	9.4%
a	7413	8.6%
o	6517	7.5%
n	6213	7.2%
l	5597	6.5%
i	5242	6.1%
r	5232	6.1%
t	4733	5.5%
s	3999	4.6%
	3436	4.0%
Other values (42)	29926	34.6%

Postal Code
Real number (ℝ)

Distinct	1697
Distinct (%)	18.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52446.327

Minimum	1001
Maximum	99362
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	1001
5-th percentile	5451
Q1	29406
median	52302
Q3	78516
95-th percentile	97035
Maximum	99362
Range	98361
Interquartile range (IQR)	49110

Descriptive statistics

Standard deviation	29374.598
Coefficient of variation (CV)	0.56008875
Kurtosis	-1.208889
Mean	52446.327
Median Absolute Deviation (MAD)	24714
Skewness	-0.042557958
Sum	4.9435908 × 10⁸
Variance	8.62867 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10177	54	0.6%
90049	47	0.5%
20016	37	0.4%
60601	36	0.4%
90045	33	0.4%
2113	29	0.3%
98115	27	0.3%
90041	26	0.3%
30318	24	0.3%
98119	23	0.2%
Other values (1687)	9090	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001	1	< 0.1%
1007	1	< 0.1%
1013	1	< 0.1%
1027	1	< 0.1%
1028	1	< 0.1%
1040	1	< 0.1%
1056	1	< 0.1%
1060	1	< 0.1%
1069	1	< 0.1%
1075	2	< 0.1%

Value	Count	Frequency (%)
99362	8	0.1%
99352	5	0.1%
99336	6	0.1%
99301	6	0.1%
99207	7	0.1%
99163	7	0.1%
98902	3	< 0.1%
98801	7	0.1%
98661	8	0.1%
98632	6	0.1%

Order Date
Date

Distinct	1419
Distinct (%)	15.1%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Minimum	2010-01-01 00:00:00
Maximum	2013-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Ship Date
Date

Distinct	1450
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	73.8 KiB

Minimum	2010-01-02 00:00:00
Maximum	2014-01-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Profit
Real number (ℝ)

Distinct	8984
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.23641

Minimum	-16476.838
Maximum	16332.414
Zeros	0
Zeros (%)	0.0%
Negative	4558
Negative (%)	48.4%
Memory size	73.8 KiB

Quantile statistics

Minimum	-16476.838
5-th percentile	-545.82
Q1	-74.017375
median	2.5676
Q3	140.24385
95-th percentile	1322.366
Maximum	16332.414
Range	32809.252
Interquartile range (IQR)	214.26123

Descriptive statistics

Standard deviation	998.48648
Coefficient of variation (CV)	7.1711594
Kurtosis	56.534342
Mean	139.23641
Median Absolute Deviation (MAD)	96.34976
Skewness	0.84141147
Sum	1312442.4
Variance	996975.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-969.048366	4	< 0.1%
11.65095	4	< 0.1%
33.98895	4	< 0.1%
-1331.553366	3	< 0.1%
-1356.667712	3	< 0.1%
-33.11	3	< 0.1%
-106.421	3	< 0.1%
-44.86	3	< 0.1%
-433.290143	3	< 0.1%
6.79	3	< 0.1%
Other values (8974)	9393	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-16476.838	1	< 0.1%
-14369.12358	1	< 0.1%
-14140.7016	1	< 0.1%
-13706.464	1	< 0.1%
-13562.63741	1	< 0.1%
-10402.94392	1	< 0.1%
-10263.6597	1	< 0.1%
-9078.94	1	< 0.1%
-8570.4483	1	< 0.1%
-7961.4309	1	< 0.1%

Value	Count	Frequency (%)
16332.414	1	< 0.1%
12504.9045	1	< 0.1%
11429.4774	1	< 0.1%
9228.2256	1	< 0.1%
9195.975	1	< 0.1%
8917.7187	1	< 0.1%
8798.1831	1	< 0.1%
8752.0428	1	< 0.1%
8202.5682	1	< 0.1%
8118.8919	1	< 0.1%

Quantity ordered new
Real number (ℝ)

Distinct	112
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.79843

Minimum	1
Maximum	170
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	5
median	10
Q3	17
95-th percentile	42
Maximum	170
Range	169
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	15.107688
Coefficient of variation (CV)	1.0948846
Kurtosis	19.004728
Mean	13.79843
Median Absolute Deviation (MAD)	5
Skewness	3.52665
Sum	130064
Variance	228.24223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	628	6.7%
9	499	5.3%
5	499	5.3%
12	498	5.3%
11	498	5.3%
3	490	5.2%
8	487	5.2%
2	482	5.1%
4	448	4.8%
7	446	4.7%
Other values (102)	4451	47.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	628	6.7%
2	482	5.1%
3	490	5.2%
4	448	4.8%
5	499	5.3%
6	438	4.6%
7	446	4.7%
8	487	5.2%
9	499	5.3%
10	444	4.7%

Value	Count	Frequency (%)
170	1	< 0.1%
167	2	< 0.1%
162	1	< 0.1%
160	1	< 0.1%
155	1	< 0.1%
151	1	< 0.1%
148	1	< 0.1%
146	3	< 0.1%
139	3	< 0.1%
137	2	< 0.1%

Sales
Real number (ℝ)

Distinct	8674
Distinct (%)	92.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	949.70627

Minimum	1.32
Maximum	100119.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	1.32
5-th percentile	14.52
Q1	61.2825
median	203.455
Q3	776.4025
95-th percentile	4209.38
Maximum	100119.16
Range	100117.84
Interquartile range (IQR)	715.12

Descriptive statistics

Standard deviation	2598.0198
Coefficient of variation (CV)	2.7356035
Kurtosis	300.12979
Mean	949.70627
Median Absolute Deviation (MAD)	174.405
Skewness	12.212531
Sum	8951931.3
Variance	6749707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46.85	4	< 0.1%
33.53	4	< 0.1%
80.58	4	< 0.1%
14.53	4	< 0.1%
119.86	4	< 0.1%
10.48	4	< 0.1%
21.9	3	< 0.1%
33.3	3	< 0.1%
36.16	3	< 0.1%
9.64	3	< 0.1%
Other values (8664)	9390	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.32	1	< 0.1%
1.62	1	< 0.1%
1.65	1	< 0.1%
2.24	1	< 0.1%
2.25	2	< 0.1%
2.66	1	< 0.1%
2.74	1	< 0.1%
2.77	1	< 0.1%
2.87	1	< 0.1%
3.07	1	< 0.1%

Value	Count	Frequency (%)
100119.16	1	< 0.1%
50332.66	1	< 0.1%
48418.58	1	< 0.1%
45737.33	1	< 0.1%
43046.2	1	< 0.1%
40136.93	1	< 0.1%
36532.46	1	< 0.1%
35147.33	1	< 0.1%
32589.59	1	< 0.1%
32510.21	1	< 0.1%

Order ID
Real number (ℝ)

Distinct	6455
Distinct (%)	68.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	82318.489

Minimum	6
Maximum	91591
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	73.8 KiB

Quantile statistics

Minimum	6
5-th percentile	28822.25
Q1	86737.25
median	88344.5
Q3	89987.75
95-th percentile	91256
Maximum	91591
Range	91585
Interquartile range (IQR)	3250.5

Descriptive statistics

Standard deviation	19149.449
Coefficient of variation (CV)	0.23262634
Kurtosis	6.9533914
Mean	82318.489
Median Absolute Deviation (MAD)	1628
Skewness	-2.8602649
Sum	7.7593408 × 10⁸
Variance	3.6670139 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90571	6	0.1%
43745	6	0.1%
88060	5	0.1%
91485	5	0.1%
86939	5	0.1%
86510	5	0.1%
89027	5	0.1%
90082	5	0.1%
87033	5	0.1%
90113	5	0.1%
Other values (6445)	9374	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1	< 0.1%
193	1	< 0.1%
322	2	< 0.1%
358	2	< 0.1%
359	1	< 0.1%
386	2	< 0.1%
388	1	< 0.1%
454	1	< 0.1%
548	3	< 0.1%
612	2	< 0.1%

Value	Count	Frequency (%)
91591	3	< 0.1%
91590	2	< 0.1%
91589	2	< 0.1%
91588	1	< 0.1%
91587	1	< 0.1%
91586	1	< 0.1%
91585	2	< 0.1%
91584	1	< 0.1%
91583	1	< 0.1%
91582	1	< 0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Row ID	Order Priority	Discount	Unit Price	Shipping Cost	Customer ID	Customer Name	Ship Mode	Customer Segment	Product Category	Product Sub-Category	Product Container	Product Name	Product Base Margin	Region	State or Province	City	Postal Code	Order Date	Ship Date	Profit	Quantity ordered new	Sales	Order ID
0	19914	Not Specified	0.08	95.99	35.00	2211	Anita Hahn	Express Air	Home Office	Office Supplies	Storage & Organization	Large Box	Safco Industrial Wire Shelving	NaN	East	Maryland	Bowie	20715	2010-01-01	2010-01-03	-425.20840	2	193.88	88028
1	24225	Critical	0.08	15.04	1.97	1155	Alex Nicholson	Regular Air	Consumer	Office Supplies	Paper	Wrap Bag	White GlueTop Scratch Pads	0.39	West	California	Montebello	90640	2010-01-02	2010-01-02	108.51630	11	157.27	90853
2	24224	Critical	0.09	9.11	2.15	1155	Alex Nicholson	Express Air	Consumer	Office Supplies	Paper	Wrap Bag	Black Print Carbonless Snap-Off® Rapid Letter, 8 1/2" x 7"	0.40	West	California	Montebello	90640	2010-01-02	2010-01-04	20.29960	4	34.41	90853
3	19279	Critical	0.06	40.98	2.99	950	Jane Shah	Regular Air	Consumer	Office Supplies	Binders and Binder Accessories	Small Box	Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets	0.36	Central	Minnesota	Prior Lake	55372	2010-01-02	2010-01-04	-14.80188	1	41.60	89083
4	23274	Low	0.05	155.06	7.07	67	Ellen McCormick	Regular Air	Corporate	Office Supplies	Storage & Organization	Small Box	Dual Level, Single-Width Filing Carts	0.59	West	California	Napa	94559	2010-01-02	2010-01-09	845.66400	8	1225.60	87946
5	5272	Low	0.00	291.73	48.80	68	Scott Bunn	Delivery Truck	Corporate	Furniture	Chairs & Chairmats	Jumbo Drum	Hon 4070 Series Pagoda™ Armless Upholstered Stacking Chairs	0.56	East	New York	New York City	10177	2010-01-02	2010-01-02	-308.92800	4	1239.06	37537
6	1279	Critical	0.06	40.98	2.99	949	Ernest Oh	Regular Air	Consumer	Office Supplies	Binders and Binder Accessories	Small Box	Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets	0.36	West	California	Los Angeles	90049	2010-01-02	2010-01-04	-19.09920	3	124.81	9285
7	5273	Low	0.07	100.98	45.00	68	Scott Bunn	Delivery Truck	Corporate	Furniture	Chairs & Chairmats	Jumbo Drum	Hon Valutask™ Swivel Chairs	0.69	East	New York	New York City	10177	2010-01-02	2010-01-04	-1679.76000	43	4083.19	37537
8	5274	Low	0.05	155.06	7.07	68	Scott Bunn	Regular Air	Corporate	Office Supplies	Storage & Organization	Small Box	Dual Level, Single-Width Filing Carts	0.59	East	New York	New York City	10177	2010-01-02	2010-01-09	575.39600	32	4902.38	37537
9	23705	High	0.09	212.60	52.20	2579	Marshall Sutherland	Delivery Truck	Home Office	Furniture	Tables	Jumbo Box	Bush Advantage Collection® Round Conference Table	0.64	South	Alabama	Phenix City	36869	2010-01-03	2010-01-04	-274.49800	1	174.50	88296

	Row ID	Order Priority	Discount	Unit Price	Shipping Cost	Customer ID	Customer Name	Ship Mode	Customer Segment	Product Category	Product Sub-Category	Product Container	Product Name	Product Base Margin	Region	State or Province	City	Postal Code	Order Date	Ship Date	Profit	Quantity ordered new	Sales	Order ID
9416	25142	Not Specified	0.10	13.48	4.51	3265	Glenn Morgan	Express Air	Corporate	Office Supplies	Storage & Organization	Small Box	Tenex Personal Project File with Scoop Front Design, Black	0.59	West	California	Fairfield	94533	2013-12-30	2013-12-30	-5.063520	18	230.45	89840
9417	24916	Low	0.09	832.81	24.49	2149	Rodney Proctor	Regular Air	Home Office	Office Supplies	Scissors, Rulers and Trimmers	Medium Box	Martin Yale Chadless Opener Electric Letter Opener	0.83	South	Kentucky	Nicholasville	40356	2013-12-30	2013-12-30	676.032000	1	803.33	91107
9418	24915	Low	0.00	19.98	4.00	2149	Rodney Proctor	Regular Air	Home Office	Technology	Computer Peripherals	Small Box	Belkin 105-Key Black Keyboard	0.68	South	Kentucky	Nicholasville	40356	2013-12-30	2013-12-30	450.327600	16	347.32	91107
9419	24361	Medium	0.10	1.48	0.70	3187	Sidney Gilliam	Regular Air	Consumer	Office Supplies	Rubber Bands	Wrap Bag	Binder Clips by OIC	0.37	South	Florida	Riverview	33569	2013-12-30	2013-12-30	-415.828000	5	7.08	89038
9420	25141	Not Specified	0.06	60.98	30.00	3265	Glenn Morgan	Delivery Truck	Corporate	Furniture	Chairs & Chairmats	Jumbo Drum	Novimex Fabric Task Chair	0.70	West	California	Fairfield	94533	2013-12-30	2013-12-30	-56.098560	3	195.56	89840
9421	24712	Not Specified	0.08	13.73	6.85	1672	Sidney Scarborough	Regular Air	Small Business	Furniture	Office Furnishings	Wrap Bag	DAX Wood Document Frame.	0.54	South	Virginia	Charlottesville	22901	2013-12-30	2013-12-30	-233.436000	23	296.94	86733
9422	21583	Low	0.09	7.28	4.23	2218	Hilda Fletcher	Express Air	Home Office	Office Supplies	Paper	Wrap Bag	Black Print Carbonless 8 1/2" x 8 1/4" Rapid Memo Book	0.39	Central	Texas	Harker Heights	76543	2013-12-30	2013-12-30	-6.269760	19	132.21	91227
9423	24553	Not Specified	0.06	12.95	4.98	2277	Allison Peacock	Regular Air	Consumer	Office Supplies	Binders and Binder Accessories	Small Box	GBC Binding covers	0.40	East	New York	North Tonawanda	14120	2013-12-31	2014-01-02	4.045184	5	65.18	91506
9424	24554	Not Specified	0.00	122.99	70.20	2277	Allison Peacock	Delivery Truck	Consumer	Furniture	Chairs & Chairmats	Jumbo Drum	Global High-Back Leather Tilter, Burgundy	0.74	East	New York	North Tonawanda	14120	2013-12-31	2014-01-02	-28.099680	1	200.57	91506
9425	24129	Medium	0.03	162.93	19.99	1090	Seth Davies	Regular Air	Small Business	Office Supplies	Envelopes	Small Box	Multimedia Mailers	0.39	Central	Illinois	Saint Charles	60174	2013-12-31	2014-01-02	2318.910600	20	3360.74	90144

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII